package com.gugee.tiktok.common.model.dal.blogger;

import com.gugee.tiktok.common.model.mysql.TBlogger;
import com.gugee.tiktok.common.model.dto.SlimBloggerDto;
import org.springframework.data.jdbc.repository.query.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface TBloggerRepository extends CrudRepository<TBlogger,Long> {

    @Query("SELECT id,uid,region FROM t_blogger GROUP BY uid ")
    List<SlimBloggerDto> getAllGroupUid();

    List<TBlogger> findByUid(long uid);
}
